Go to Finance ➔ Reports ➔ Balance/PL and click the Transaction list button.
A transaction list is a report listing all the transactions made for each G/L account per period (month).
You can filter the report that you want to display. To search for the report, define one or more of the following criteria and click Start. The report that matches the search criteria you have entered is then displayed.
Select the account type for which to generate the transaction list. You can choose from Balance sheet, Profit & Loss, and Balance Sheet/Profit & Loss.
Select Previous year or Budget to display the column(s) in the transaction list with the corresponding data.
Note: Budget is only available if you have the E-Budget module.
Select the required factor to display the amount in the transaction list report. Choose from 1, 10, 100, 1000, or 1000000. These numbers are useful when working with large amounts because the system will divide the amounts found in the report with the selected factor. For example, if you have selected a factor of 1000, the amount of 350,000 is displayed as 350 instead. By default, the value is set to 1.
Select the required option to determine whether the invoice currency is based on All – Invoice currency, All – Default currency, the default currency, or other foreign currencies that are registered in the settings. If you select a foreign currency, only the entries that have been posted in that currency are selected. If you select All – Invoice currency or All – Default currency, all entries are displayed, irrespective of the currency code.
Select this check box to include the opening balance for each period in the transaction list report. When this check box is selected, the Columns field will be disabled.
Select this check box to include unprocessed entries in the report.
Select the number of digits to be displayed after the decimal point (maximum of 3).
Select the financial year for which you want to view the transaction list.
Type the period (month) range (from 1–12) for which you want to view the transaction list or select the All check box for all periods.
Type or select the G/L account range or select the All check box for all G/L accounts.
Type or select the country code for which you wish to view the transaction list.
Type or select the cost centre range or select the All check box for all cost centres.
Type or select the cost unit range or select the All check box for all cost units.
Type or select a budget scenario to add additional columns to the overview. The additional columns will display the budgets according to the budget scenario and the variation in percentage terms.
Note: Budget scenario is available if you have the E-Budget module or have selected Budget at Columns.
Click this to generate the transaction list report based on the selected criteria.
Click this to exit.